SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_ExportEmployer]
AS 
    SELECT  JOL_Employer_Account,
            JOL_Employer_Name,
            JOL_Employer_Linkman,
            JOL_Employer_Mobile,
            JOL_Employer_Email,
            JOL_Employer_Phone,
            JOL_Employer_Fax,
            JOL_Employer_VerifyStatus,
            JOL_Employer_IsSchoolCorperate,
            JOL_Employer_IsVIP
    FROM    dbo.JOL_Employer
    ORDER BY JOL_Employer_VerifyStatus DESC,JOL_Employer_IsVIP DESC

GO
